C:\Users\soob\Downloads\ACCT 371 Project Part 1 Data.xlsx|||`Indianapolis$` False 1 Import the data from the Excel workbook "Indianapolis" sheet. ACCT 371 Project Part 1 Data.xlsx Query=`Indianapolis$` Warn Transpose data to make transaction list of all possible Customer and Employee Travel Distances Transpose data to make transaction list of all possible Customer and Employee Travel Distances C:\Users\soob\Downloads\ACCT 371 Project Part 1 Data.xlsx|||`KansasCity$` False 1 Import the data from the Excel workbook KansasCity" sheet. ACCT 371 Project Part 1 Data.xlsx Query=`KansasCity$` Warn Transpose data to make transaction list of all possible Customer and Employee Travel Distances Transpose data to make transaction list of all possible Customer and Employee Travel Distances Warning All ByName Union all travel distances into a single file Union all travel distances into a single file C:\Users\soob\Downloads\ACCT 371 Project Part 1 Data.xlsx|||`Louisville$` False 1 Import the data from the Excel workbook Louisville" sheet. ACCT 371 Project Part 1 Data.xlsx Query=`Louisville$` C:\Users\soob\Downloads\ACCT 371 Project Part 1 Data.xlsx|||`Nashville$` False 1 Import the data from the Excel workbook "Nashville" sheet. ACCT 371 Project Part 1 Data.xlsx Query=`Nashville$` C:\Users\soob\Downloads\ACCT 371 Project Part 1 Data.xlsx|||`StLouis$` False 1 Import the data from the Excel workbook "StLouis" sheet. ACCT 371 Project Part 1 Data.xlsx Query=`StLouis$` Warn Transpose data to make transaction list of all possible Customer and Employee Travel Distances Transpose data to make transaction list of all possible Customer and Employee Travel Distances Warn Transpose data to make transaction list of all possible Customer and Employee Travel Distances Transpose data to make transaction list of all possible Customer and Employee Travel Distances Warn Transpose data to make transaction list of all possible Customer and Employee Travel Distances Transpose data to make transaction list of all possible Customer and Employee Travel Distances Rename column titles to EmpAddress and ValidatedMileage Rename column titles to EmpAddress and ValidatedMileage C:\Users\soob\Downloads\ACCT 371 Project Part 1 Data.xlsx|||`Trips$` False 1 Import the data from the Excel workbook "Trips" sheet. ACCT 371 Project Part 1 Data.xlsx Query=`Trips$` Join all data together to form one file for analysis Join all data together to form one file for analysis C:\Users\soob\Downloads\ACCT 371 Project Part 1 Data.xlsx|||`EmployeeData$` False 1 Import the data from the Excel workbook "EmployeeData" sheet. ACCT 371 Project Part 1 Data.xlsx Query=`EmployeeData$` Join data from "Trips" sheet and "EmployeeData" sheet Join data from "Trips" sheet and "EmployeeData" sheet Create field EmpFullName that concatenates first and last name together C:\Users\soob\Downloads\ACCT 371 Project Part 1 Data.xlsx|||`CustomerData$` False 1 Import the data from the Excel workbook "CustomerData" sheet. ACCT 371 Project Part 1 Data.xlsx Query=`CustomerData$` Join data from new combined data and "CustomerData" sheet Join data from new combined data and "CustomerData" sheet Sort data by RowID RowID - Ascending Separate workflow for min/max per customer Join new min/max data with original data [ValidatedMileage] = [Max_ValidatedMileage] Custom Filter max with validated mileage [ValidatedMileage] = [Max_ValidatedMileage] Custom Filter min with validated mileage Sort CustAddress and EmpAddress by ascending CustAddress - Ascending EmpAddress - Ascending Sort CustAddress and EmpAddress by ascending CustAddress - Ascending EmpAddress - Ascending Remove Duplicates Remove duplicates Connect EmployeeData to Max Connect EmployeeData to Min Create MaxEmpFullName field Create MinEmpFullName field Combine min and max data streams Check the columns needed in final dataset for Pt2 Sort final data by RowID RowID - Ascending C:\Users\soob\OneDrive - USC Marshall School of Business\ACCT 371\ACCT 371 PROJECT PT 1\Solution Part 2_BrandenSoo.xlsx|||Solutions Part 2_BrandenSoo False False False False Create Solution Part 2_BrandenSoo.xlsx Query=Solutions Part 2_BrandenSoo Horizontal Project Part 1 Part 2_BrandenSoo